Stored Procedures [dbo].[BAECartBillingInsert]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@CartItemIdint4
@ProductCodevarchar(256)256
@Titlevarchar(256)256
@DuesTypevarchar(256)256
@Pricemoney8
@IDvarchar(10)10
SQL Script

create procedure [dbo].[BAECartBillingInsert] @CartItemId as
int,
    @ProductCode AS varchar(256),    
    @Title AS varchar(256),    
    @DuesType AS varchar(256),    
    @Price AS money,
    @ID As varchar(10)
AS
    INSERT INTO CartBilling
    (
    CartItemId,
    ProductCode,
    Title,
    DuesType,
    Price,
    ID)
    VALUES
    (
    @CartItemId,
    @ProductCode,
    @Title,
    @DuesType,
    @Price,
    @ID);
SELECT CAST(@@IDENTITY AS int) AS CartBillingId


GO
Uses